UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7OzKWmrjE6be1InpYaGVMIe4Nq+Y1OlPN3fJuDJvSqA='
WHERE
key_id = '9521f9d1ef9f7cc62651943e3b325f2172acb505de73951a7c940ca9774c2894'
AND (
token = '7OzKWmrjE6be1InpYaGVMIe4Nq+Y1OlPN3fJuDJvSqA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)