UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6qzxcwi8ELxpOmWI8cLD7eJLnQEUDmEaibIS945cSlA='
WHERE
key_id = 'dc9a9ce0064afd9d1063e11dac39dd5c05144e71591bf5f6b5bfec9455f72bd1'
AND (
token = '6qzxcwi8ELxpOmWI8cLD7eJLnQEUDmEaibIS945cSlA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)