UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mhkjlA/lU0gLSy77+HuWbS+DWCW5BxGkXnSH1m5rkvY='
WHERE
key_id = 'ea47533415e7fbb7616d7b12426a4699d8fc46bff7353ee193372c99c2acee5c'
AND (
token = 'mhkjlA/lU0gLSy77+HuWbS+DWCW5BxGkXnSH1m5rkvY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)