UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'foiySZ1e9wENMIa0v0jY8QFHI4vGLdc5n8dZcFYls/c='
WHERE
key_id = 'c4b5513ff3a9501e7e8dde7eddee76c5d92c0af6c0bc92baabbd8bdd64e72cfc'
AND (
token = 'foiySZ1e9wENMIa0v0jY8QFHI4vGLdc5n8dZcFYls/c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)