UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'upL2S6v0X395nrTFdr8DDVbjTfiXIGcBO5sKZmMgmRs='
WHERE
key_id = '0b3d835ab634f92bafe88818e2779286bc6a2849b02c4a233994392ba113bfae'
AND (
token = 'upL2S6v0X395nrTFdr8DDVbjTfiXIGcBO5sKZmMgmRs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)