UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ThT8gY0RhUeH56P9Ur81/01Ta8yHT5FWLPcUIn1dec8='
WHERE
key_id = '8d31698eca90c920788cb6e06fa1a9046c18bca5f3384bd7d66d3785b1855d79'
AND (
token = 'ThT8gY0RhUeH56P9Ur81/01Ta8yHT5FWLPcUIn1dec8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)