UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yZM1gzIbl+J2o5y3dL6XtbIG5AXWd9s/aEBUR9ANsF0='
WHERE
key_id = 'cc8e098918d3fc786f4ddb6ee20bdaafaceee02b1f4e3b0530c20d04ceae5d81'
AND (
token = 'yZM1gzIbl+J2o5y3dL6XtbIG5AXWd9s/aEBUR9ANsF0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)