UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'agRHJDaVmILcUGmGwvFHbtty+jKxhbCmN5BR2ZshmMU='
WHERE
key_id = '9a78d93164504d4afa243660c4aab41768a4f0a4a008078c5ae6a3374436f111'
AND (
token = 'agRHJDaVmILcUGmGwvFHbtty+jKxhbCmN5BR2ZshmMU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)