UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qi0LnlFFdob2X7K9XPzTfNwUFEw22wmoIew3zdEk8+w='
WHERE
key_id = 'e33312e4a8abdd1028b3a27dd926c9fe8ce7c7be0c385506e745b294d3a2e7b2'
AND (
token = 'qi0LnlFFdob2X7K9XPzTfNwUFEw22wmoIew3zdEk8+w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)