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