UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XXDQKrnfOcEW0t5deOCo4iFPVVV3QorvJOlL2SJyk/8='
WHERE
key_id = 'dd9b19ad68fb7eb29b425873dc518e105f47e987ab5527c21f49064ad9de85d3'
AND (
token = 'XXDQKrnfOcEW0t5deOCo4iFPVVV3QorvJOlL2SJyk/8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)