UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n6KZPICo27Yo1djncV3SAHkqzqAKNjuy4/hwfB4cMW0='
WHERE
key_id = '059a64218482973f0462d25b24ecfc541aaf39f4a957e1e2401bad0754ad28dd'
AND (
token = 'n6KZPICo27Yo1djncV3SAHkqzqAKNjuy4/hwfB4cMW0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)