UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n1Fa8B3ZSpqzUXUFYvKs0GRiVUaUUW3EvRoSTXXPhpc='
WHERE
key_id = 'b465d1983a6578da1a672d807ddfa9d0049572e800c6837606e08c146125259f'
AND (
token = 'n1Fa8B3ZSpqzUXUFYvKs0GRiVUaUUW3EvRoSTXXPhpc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)