UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fVHbbp9wwc4fCVTLDiMQw99zHaGdjrFVV4SqJTtL2d8='
WHERE
key_id = '5986fefad02404c15f84c99990cf71844c68a003fa53e0389a6901d89e81f47f'
AND (
token = 'fVHbbp9wwc4fCVTLDiMQw99zHaGdjrFVV4SqJTtL2d8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)