UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3iDHcQ+9IlnldEGswUYpBfJVle0Twu7NF+83vT+nIhw='
WHERE
key_id = '4e9e5956dad2b51e8e9fa02844747da88f076ef1bcdd7ccfd733467775094078'
AND (
token = '3iDHcQ+9IlnldEGswUYpBfJVle0Twu7NF+83vT+nIhw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)