UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GcXmT0TAUNdS0J4UdglgDBmrrJZ7C6Cd2t97qQdV1t4='
WHERE
key_id = '42e02ed5578d84b8beeab32e103a7ba92b42145ac3e0b11e535a900bf3ed981e'
AND (
token = 'GcXmT0TAUNdS0J4UdglgDBmrrJZ7C6Cd2t97qQdV1t4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)