UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B3zDLgM8BFoAhAt017qdd2BXtoV9K3HrhfjabiOFdSI='
WHERE
key_id = '65e973dad91735061e1b14539467f79632c325a7acaa2dd838ef4206df847c5a'
AND (
token = 'B3zDLgM8BFoAhAt017qdd2BXtoV9K3HrhfjabiOFdSI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)