UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gXycum0PTBqfxtlHoswChtYOWaNEDNAL7TMdkymTnMw='
WHERE
key_id = '03fdb93b06835d38348772968f88a327167b19527e0f0759729fec22f828ec96'
AND (
token = 'gXycum0PTBqfxtlHoswChtYOWaNEDNAL7TMdkymTnMw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)