UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tj5w02KG9ahkbg1tr/aFCwrRey9s1Lh6WRO/8Jo2FYg='
WHERE
key_id = '6b8f24872a63b886953d935c3fc7df39ca753bc57aafad84726ab010087104e8'
AND (
token = 'tj5w02KG9ahkbg1tr/aFCwrRey9s1Lh6WRO/8Jo2FYg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)