UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xLB4sjhPct1TN/P0Dx+OZoybmnkVYlY0SfRb+x86VoA='
WHERE
key_id = 'a6ed3a6563dd6364747904f105abf437b34a1199947b9bd5fef79a7909e98c0a'
AND (
token = 'xLB4sjhPct1TN/P0Dx+OZoybmnkVYlY0SfRb+x86VoA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)