UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G9INtvJGG8NyeP4y35+0uiBeRs2n+F5nZiKxC2JpS6c='
WHERE
key_id = '1e861f16639ab74895b5a9265ad4f92a637823a1dbe0c15acfce7d7b6b9cdd38'
AND (
token = 'G9INtvJGG8NyeP4y35+0uiBeRs2n+F5nZiKxC2JpS6c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)