UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QiW03d+yyD9BreVd3gYHL2ypZH+11PplpZOR5cdhuLk='
WHERE
key_id = '494355181bd28172ffebcf9be6c0b48dd13dcd9903f810f81e9fab3e34c20a99'
AND (
token = 'QiW03d+yyD9BreVd3gYHL2ypZH+11PplpZOR5cdhuLk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)