UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4lyAFjJ7OwkaZL5J4rn2ils24CcBPzTxFngVyX+RAM0='
WHERE
key_id = 'c552ce31b4b9ec9a8793119c8298e3b0bd87c7ff82b9a9a3789df552bb0b932f'
AND (
token = '4lyAFjJ7OwkaZL5J4rn2ils24CcBPzTxFngVyX+RAM0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)