UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r42wvXI4D6cmo8IRMRdaw9B+oiLfChlGqOkX5lV1bkk='
WHERE
key_id = '44d188563b4ccb042bc46d1ccf975fba4a2d04d21eafaef0ae2767734899598b'
AND (
token = 'r42wvXI4D6cmo8IRMRdaw9B+oiLfChlGqOkX5lV1bkk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)