UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9HMlpXtqy/glfR2yleEN0q+ROzEzi8aytYq+PPK8zmU='
WHERE
key_id = '5ac8d14df0c60eb8b17c09933195a593afc8d75181a4914967a8e895ab16988c'
AND (
token = '9HMlpXtqy/glfR2yleEN0q+ROzEzi8aytYq+PPK8zmU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)