UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '47+w/BLdRf+noVV7jeB8Olld7+rYop+tkmsqN2C3cIM='
WHERE
key_id = '3e7700d47289ac2e8c0e41c3f67f027a216042501dccafbc2f9c09a29a6ae293'
AND (
token = '47+w/BLdRf+noVV7jeB8Olld7+rYop+tkmsqN2C3cIM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)