UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xDg2y4M8IlbQ2CxV7WgsFUUxa+S4w1iv+O0tONMecfo='
WHERE
key_id = 'a4ac2c677c10313ae547d4f25e597364c769424a711cc67007a15db5bb7894c8'
AND (
token = 'xDg2y4M8IlbQ2CxV7WgsFUUxa+S4w1iv+O0tONMecfo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)