UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dsZzEW4Ap8pm0sAo7EoBJ4Z3Q6f6/0FjvcE/1RYrnHE='
WHERE
key_id = '2e5627f3fe6781e836ad0642c78ded5e4c7b3452eb364cb19eadc98a40767a51'
AND (
token = 'dsZzEW4Ap8pm0sAo7EoBJ4Z3Q6f6/0FjvcE/1RYrnHE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)