UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nQe/Y+BhZKeK66fkABPURMqk0hjTz5Y3mwPePvAkcFk='
WHERE
key_id = '47d6e7034e532d7c5e6ced699ff1b3443514cc1123c21ef878d05c5aaf9f0e02'
AND (
token = 'nQe/Y+BhZKeK66fkABPURMqk0hjTz5Y3mwPePvAkcFk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)