UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X8pPQbzYLq/1ONQHnui9Zm3zndDOL40hZ7Kl6NeGIMI='
WHERE
key_id = '12bb273255d779d84492e86c28aa8d791f5a28042f2641e220c77acfbb4e8d03'
AND (
token = 'X8pPQbzYLq/1ONQHnui9Zm3zndDOL40hZ7Kl6NeGIMI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)