UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qU4UzroJZPq6isH+7whZwpsaBUPTalaDXn1Ae7yg5HE='
WHERE
key_id = '567d8354e0c3bb53ef174d163a208548adda3a7fb7f028ea6f7868a89f4001e8'
AND (
token = 'qU4UzroJZPq6isH+7whZwpsaBUPTalaDXn1Ae7yg5HE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)