UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6+TxYkzaGZam60ceEuFiEYWZmvkJ6hC42F4F84cKVEk='
WHERE
key_id = 'eb183a64b751d31c9cb004ee2c48898af98528495efb1448c5c8179a8dc00165'
AND (
token = '6+TxYkzaGZam60ceEuFiEYWZmvkJ6hC42F4F84cKVEk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)