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