UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8ACU0ncB+i9gDnV9QDoe6MjYAokmZy4BfmMjEoWO+dI='
WHERE
key_id = '10e1409f6bf755c7d7448dd387e3c22c15a03fbe5a69e3845c561a48b6504201'
AND (
token = '8ACU0ncB+i9gDnV9QDoe6MjYAokmZy4BfmMjEoWO+dI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)