UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vB1fV8ANJFTACcrsMOEo8Ak/8pxbpBhtXOHotxsg0xs='
WHERE
key_id = '20bf1f111cc380f5e514d8819f0a1a53512439aeaf76e20040b379ad17637865'
AND (
token = 'vB1fV8ANJFTACcrsMOEo8Ak/8pxbpBhtXOHotxsg0xs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)