UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7LaXcA/Xa8GRdNnmYuQLoavbCp3+POUKdolxmUmOCTU='
WHERE
key_id = 'ca8e546ba223165644036fb5b153b64228e5c2c6e221c2d657a276415902df38'
AND (
token = '7LaXcA/Xa8GRdNnmYuQLoavbCp3+POUKdolxmUmOCTU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)