UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n4jL7qCHHaHCmD9nmYd5l9qEeeIsGtuTkIjOV+WscP0='
WHERE
key_id = 'd38240516f2a3f39360309917087df577f5f0e79253e5520ad84ee4f8bd548ec'
AND (
token = 'n4jL7qCHHaHCmD9nmYd5l9qEeeIsGtuTkIjOV+WscP0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)