UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gn10YAkhr2pbu2XhTuU+KYCKsV6rrT94XI+C4y61wdk='
WHERE
key_id = '9ea9d056824e52a43853b0d8b8d64a243b7200edcef3db79437d4a40da0d6418'
AND (
token = 'gn10YAkhr2pbu2XhTuU+KYCKsV6rrT94XI+C4y61wdk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)